Use the Index Name edit box to set the index name.
To include field(s) in the index, click to open the editor for editing under Fields.
The Index Type dropdown list defines the type of the table index. Oracle Database provides several indexing schemes.
Non-unique
Non-unique indexes do not impose the restriction of unique indexes on the column values.
Unique
Unique indexes guarantee that no two rows of a table have duplicate values in the key column (or columns).
Bitmap
In a bitmap index, a bitmap for each key value is used instead of a list of rowids.
Parallel with degree
Parallel indexing can improve index performance when you have a large amount of data, and have multiple CPUs.
Enter the degree that determines the number of separate indexing processes.
Schema
The schema in which to create the index.
Note:
To create an index in your own schema, at least one of the following conditions must be true:
- The table or cluster to be indexed is in your own schema.
- You have INDEX privilege on the table to be indexed.
- You have CREATE ANY INDEX system privilege.
To create an index in another schema, all of the following conditions must be true:
- You have CREATE ANY INDEX system privilege.
- The owner of the other schema has a quota for the tablespaces to contain the index or index partitions, or UNLIMITED TABLESPACE system privilege.